﻿if exists (select * from sysobjects where id = object_id(N'pBUGLOGRolesDelete') and sysstat & 0xf = 4) drop procedure pBUGLOGRolesDelete 
GO

-- Deletes a record from the [dbo].[Roles] table.
CREATE PROCEDURE pBUGLOGRolesDelete
        @pk_RoleID int
AS
BEGIN
    DELETE [dbo].[Roles]
    WHERE [RoleID] = @pk_RoleID
END

